SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101963 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101963 [ RunTime:0.002349s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (928529,642694,481240,255206,77247,848633,283585,916936,340973,296871,158950,484516,379701,946660,988360,924400,40910,1003637,507841,1002516,1018125,129941,676082,863153,195870,106676,650032,554121,937088,389441,60197,124503,435654,1028803,553679,665372,574654,314725,291202,450616,626523,941807,783190,84805,328858,957805,927558,336967,1038372,83373,897805,1027674,358675,380104,883465,328719,371875,96242,1047963,275104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]