SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467918 LIMIT 1 [ RunTime:0.000744s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467918 [ RunTime:0.001531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (62309,938407,1044161,608841,459492,953456,122682,629948,308138,157825,875995,306340,931200,75117,686049,974994,864934,226407,485704,1001130,229142,743893,518523,48529,579527,938322,362862,683234,701418,976069,43443,557327,243906,892584,987691,530525,199671,354697,599845,919443,804160,362437,681551,873708,831631,937821,989979,632027,815585,783924,132967,834752,66591,479441,562367,655967,10050,714838,286900,909404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]