SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013680 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013680 [ RunTime:0.002279s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427855,126673,421194,1020474,792234,521458,1020583,259628,879049,473476,1024204,584893,736222,593901,368708,966578,74893,611528,184089,72930,684885,931845,494244,805635,821628,362174,1002849,538830,758985,177986,436111,56331,585389,1003185,241481,141124,159961,973912,781734,993310,635271,739113,430084,995381,624855,298938,503012,855636,819046,990957,567481,599641,233991,971034,111099,305873,399855,865300,1023486,503201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]