SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001051 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001051 [ RunTime:0.002427s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943968,320414,413980,643116,358524,52913,321099,786596,364481,50044,237477,615960,507767,548408,590426,600485,1019548,118694,817709,915728,565000,1042585,733894,64481,623423,353501,679966,342498,557262,539994,339787,289387,970986,823021,116837,976561,890221,908915,551160,828509,443590,90473,24268,520044,117886,264157,959500,594408,322106,198205,467281,1982,340034,648239,434849,325673,38606,193612,720743,185800) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]