SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406085 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406085 [ RunTime:0.002553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262413,134121,719316,388008,1010308,965479,674894,1010781,332631,369069,245026,567719,1001009,97482,259508,841856,434346,1033087,885844,607036,197470,151255,860682,603561,431754,55157,143645,711230,96394,593414,972921,611986,235375,534573,810188,361441,975790,359872,132191,212040,547004,834699,745579,121276,913598,643839,831608,538183,996281,629157,501806,205477,616087,276395,49700,930187,21478,774698,204171,1042112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001106s ]