SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281022 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281022 [ RunTime:0.002005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (864711,256248,134419,509220,241650,706338,102794,330133,161626,142793,178813,111331,91199,157985,842880,985643,615669,595069,82583,794335,882181,794954,970779,790155,868487,220544,593007,235829,826109,230570,454103,207694,943043,344105,533824,577345,469320,663289,397265,866536,1045934,993631,429857,561218,401794,808623,49191,473307,387450,796523,560726,532411,1044100,874200,437365,656406,926496,520229,735387,492651) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]