SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002070s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406767 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406767 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (361058,536380,599418,405050,1023130,146350,764222,695072,1045061,264170,722288,590089,325673,92890,894898,398694,391165,533469,369130,404896,211545,24694,104759,565126,363112,1005800,777461,736808,320786,18386,799063,916296,696959,587374,532187,876903,800505,373416,1019893,419363,661925,186257,890552,470213,759365,705941,15086,320682,153983,553199,34009,434938,42903,241994,516209,110596,343985,657321,876720,818900) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406767 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406767 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003705s ]