SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001814s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504673 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504673 [ RunTime:0.002777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754510,142084,716428,1004754,467001,198792,19891,85026,581391,982010,494953,388410,174979,89131,597570,176214,313333,499090,117144,427065,479321,440526,752575,89511,708677,967172,911098,581460,823566,464111,162787,506446,608460,984213,246375,543809,516079,743134,624103,232388,680239,382764,514755,667162,313139,876457,576271,296187,798356,878821,56253,158090,606781,58777,864431,555151,549087,29105,267340,836283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001784s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504673 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504673 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001585s ]