SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516445 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516445 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (686163,21492,698213,142209,165681,1017948,213142,520045,48918,14845,28969,579143,926955,478464,453334,981646,839354,627072,855207,118487,412526,964967,571047,37769,270203,307722,839267,75398,939358,238758,310679,90549,1019536,971264,243617,709715,838609,93453,456702,20081,421975,307418,18442,352547,561256,759910,272057,545845,214019,814605,992984,700685,283904,787484,241208,766550,70625,920821,600901,285549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]