SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002440s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002075 LIMIT 1 [ RunTime:0.000602s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002075 [ RunTime:0.002524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018822,926075,367188,424925,828941,437125,702828,960336,49187,768141,108233,1030503,526485,71252,102560,837320,747569,426642,565703,584542,339582,886299,644142,577672,650170,943776,425771,25611,1016955,786172,623593,167732,857964,16821,557189,730821,908087,965299,704068,939093,924900,223595,319638,970651,701074,33348,323572,274973,770715,909976,297285,324186,453030,1002680,551247,778256,397053,564393,45415,998121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]