SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554364 LIMIT 1 [ RunTime:0.002130s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554364 [ RunTime:0.009812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (926899,999665,695040,1019050,1038209,226073,986914,280855,529421,105375,719241,48528,411266,14928,1023583,206896,231160,974396,667490,405669,480674,881655,1016244,604585,737122,413673,433919,435810,551997,508611,241933,6028,9873,630668,137293,633017,21655,61139,523871,997654,1529,628776,606563,45866,420577,480916,798724,689610,284031,906729,100554,1022415,1046786,1034939,815224,542112,478157,517172,263059,321387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.037908s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554364 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554364 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002657s ]