SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532912 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532912 [ RunTime:0.001885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (960598,1000050,321683,576873,1023480,306868,352520,1021904,720923,307318,452528,153483,388301,201950,389156,265681,387832,977033,783010,890847,146698,368874,951560,825112,478895,391400,789322,911702,1004781,180911,873909,672932,223607,53391,907252,1007599,315179,707104,255777,978772,299421,10793,572083,1033911,924252,321965,917537,264556,724511,161907,559974,518815,726433,402581,409747,588849,649660,896103,525938,987001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003655s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]