SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542013 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542013 [ RunTime:0.001485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703803,493781,738268,195242,362929,703181,873299,162393,263289,911457,766561,958032,198475,276788,43659,184148,59194,171212,707092,59349,887154,38179,975861,583796,876988,825908,310855,733437,460869,334898,995248,65199,387846,496724,33815,803296,360798,753572,197660,464401,677048,23394,54592,269592,97918,1003357,537659,869390,530703,970396,9218,629233,271490,147875,840163,179110,547258,719994,959160,606850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]