SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447583 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447583 [ RunTime:0.002265s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (73916,913224,154167,772890,580163,264434,316746,824445,275053,398338,242190,105136,1044222,405730,352679,15608,189311,151375,580407,292831,649910,789524,1004037,896056,271408,23501,55637,671731,667787,196342,678373,238045,355593,614550,518605,109626,1037290,687999,342209,415351,580318,660967,593461,286266,175684,713372,695454,333908,636246,248934,138490,803226,494402,671569,991501,107862,726996,418557,350232,348322) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]