SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048107 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048107 [ RunTime:0.002164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147343,816131,386440,318787,899245,717860,121250,363663,906109,471212,765823,526245,253990,658187,1024922,284821,513623,807796,324019,703974,627682,153311,512588,1035917,900349,402237,824815,275775,195996,367769,630850,543327,705486,1020239,72179,320540,684500,403672,129628,630263,122265,492260,776485,345919,278872,663032,166161,701139,928853,267008,489178,1003644,943929,632769,108612,349182,96703,968670,839638,864154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]