SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559073 LIMIT 1 [ RunTime:0.000515s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559073 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434156,354772,661046,526149,223363,385421,550489,121943,122027,715532,469128,526453,784375,567691,599901,860178,834955,274915,326380,198278,379456,50157,338007,618706,903680,21149,926910,217050,81341,915667,835193,957676,61277,173086,594521,851979,30033,229308,350331,286702,616399,37288,370743,606944,876236,237635,1036190,687132,256395,343766,235662,808394,940539,602515,506257,540154,822557,315441,435785,933473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]