SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501194 LIMIT 1 [ RunTime:0.001472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501194 [ RunTime:0.004338s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399477,485870,388254,2726,447130,17821,812297,517679,443597,418664,220102,627580,600515,920697,29527,428830,346075,967304,402657,464233,393907,636009,1032837,672678,261206,832559,515713,375995,813423,779523,292037,591301,856295,535340,747275,560669,421841,37117,78991,678612,943554,336553,413503,851667,488358,188982,660799,264634,286812,521132,680122,768469,499972,665425,462987,649437,67220,1012739,521106,652982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.036509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002040s ]