SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002060s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402750 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402750 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (579402,939278,953516,744103,687554,934403,78426,27190,831382,780381,201335,1027788,223408,384737,453234,924770,236298,731513,420846,96049,154975,980707,357381,983016,1019628,930646,863997,74854,97837,931267,988327,681312,771822,120904,658964,476303,78594,587355,604688,864843,101613,866678,80582,710574,740555,835386,514078,27271,912901,654826,801627,810660,657466,957562,413402,968697,624401,971774,490505,21780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402750 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402750 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000740s ]