SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020861 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020861 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111871,783203,732262,475681,281605,825077,396383,544264,819614,1044528,956019,618370,113144,166255,457757,16470,830632,972520,1028452,159884,145371,389719,473505,196565,833912,329264,167241,204118,257592,678392,157726,908023,693284,118905,614914,545911,882140,461563,361380,523962,37627,770306,605615,817915,1031735,865589,380750,439915,44862,90245,276941,982167,717311,56929,759645,235012,1046892,43454,367453,347259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]