SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001675s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285412 LIMIT 1 [ RunTime:0.000533s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285412 [ RunTime:0.002237s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (756184,198951,91335,1014586,285956,995984,422162,566318,607001,636997,561866,273451,398036,893498,964915,718014,707937,141094,404962,387740,641117,622707,454987,121939,775952,98706,679593,777820,903574,526204,662852,967359,298231,329849,1028053,384495,357302,967090,882214,188628,48292,451786,855777,87195,967507,652196,245135,923201,696527,36856,800027,1015450,871335,999722,635594,227021,708220,753192,45464,591196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]