SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536048 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536048 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243339,402109,784863,412470,334777,1001470,189648,990104,361888,1000338,79665,1033829,851282,1014120,134821,740029,361022,329908,155617,942749,891906,578680,467983,17193,604537,291804,809220,588291,663341,685739,649589,814761,329810,348404,425720,402006,1011640,420359,51951,640849,271912,77449,346366,403444,556279,148493,478649,491009,308051,589902,48357,118340,547681,354389,918187,857517,547106,210145,989815,71026) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]