SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415281 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415281 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (792935,330578,789389,767734,850616,955821,638414,671124,402310,547109,238742,837948,926840,926589,827292,731785,528746,825213,646500,111377,110332,556654,753085,64735,881588,346793,1046151,929056,978259,452463,519170,907910,850875,996656,634279,758632,18543,197730,414533,900851,15989,351892,992917,30290,489951,390347,428774,791674,143043,647950,354798,316160,433060,149051,993751,76507,404269,289687,109288,271420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000737s ]