SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196354 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196354 [ RunTime:0.001458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501313,494150,953603,760542,9143,965039,124203,1040960,1004062,185625,757720,138235,490971,310468,321374,951470,674001,167297,838657,3767,33806,914897,747483,703613,502905,789686,788279,706916,486949,773778,622433,801055,802113,470514,240760,68108,243271,344633,235844,416611,293953,395233,399073,612070,578587,977278,259550,358877,39700,199244,399620,412024,954082,579684,397060,1008753,328007,1025074,336710,603286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001138s ]