SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514938 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514938 [ RunTime:0.001509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809047,414569,378110,471809,256350,755734,127360,358602,163818,601655,532552,97265,563611,275820,125430,911823,732489,347665,895515,397916,1035582,325321,1037881,747392,729112,567328,25291,722306,115709,609013,665341,587607,1003083,505393,745155,43880,382388,508548,332799,286061,634634,470072,118862,788420,936609,783825,857617,75839,490003,350345,485570,704289,46882,401001,599022,641144,888104,921141,773964,76618) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]