SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002518s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50261 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50261 [ RunTime:0.002132s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10367,361936,106688,121349,552652,548657,853664,849983,975147,500936,795259,493490,317161,843005,696386,426812,214338,363119,678987,336898,104509,466758,592605,655150,885653,172578,706134,83295,326480,4110,762533,865580,128274,788087,857642,85799,746055,50803,935861,365142,423272,518706,528003,693678,182688,468699,960536,538530,966138,449217,8911,841060,13146,726180,500711,974899,131537,239308,181860,212095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50261 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50261 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]