SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579291 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579291 [ RunTime:0.001542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (963660,772905,1016862,857605,743733,255086,47095,438570,459409,998983,465588,374823,169315,593655,372169,127385,672035,590897,658729,716586,411762,168024,928536,9634,629585,86631,1019219,95700,497397,651289,608254,60248,273007,459100,1008174,487236,741264,479457,74752,975329,445605,389874,264864,894887,1002093,855657,328992,268381,1041968,88236,705249,951976,640509,552026,724919,982887,13490,935828,703461,1004379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002525s ]