SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505442 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505442 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447929,741904,925265,678207,120869,504380,513620,313652,916344,333279,423896,108309,20666,315836,137618,246182,789415,187261,204328,1005802,355428,969368,458887,710298,150395,210438,631651,116450,60007,314080,9639,90269,194557,837219,21091,766492,745437,603647,332667,1009317,247945,886733,316895,615046,1007365,215316,540698,775823,697269,430157,592466,1023359,668984,932132,427536,201765,792746,613275,678707,111895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]