SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 321518 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 321518 [ RunTime:0.001413s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443824,78074,392752,777510,856292,519702,832453,414392,576434,153938,898751,122638,125572,136554,432326,22751,849120,273590,872167,156837,64247,727414,989737,188204,338179,518168,545000,83394,639546,337832,665103,496724,450840,268475,685941,1028477,627726,879938,909054,934515,991842,6712,883605,794731,1010565,504354,173466,41316,619235,948146,104501,334495,159738,560969,27153,343251,706339,643605,12522,172325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 321518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 321518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]