SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20563 LIMIT 1 [ RunTime:0.000491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20563 [ RunTime:0.001814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43377,1035309,637765,66543,804412,427168,158216,997913,966888,1011667,680956,38725,587994,185271,13458,459759,401601,285167,523050,86804,611689,979240,59139,441697,128577,867496,737212,175665,181876,907010,1021831,1033778,409437,524388,652038,1007527,444607,389653,291932,606880,144601,973962,895287,809790,674125,372253,689278,371057,681683,231988,369396,910776,888634,315892,857026,516200,753473,913816,836139,829549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]