SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529597 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529597 [ RunTime:0.005719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (606183,124623,915052,1036075,60302,200537,850697,453792,834555,63681,315300,713337,945391,411182,102168,526173,141616,111764,279824,125273,343947,1009934,741215,220153,709748,206787,878395,153275,846087,117931,373960,997785,475696,74148,296915,86711,726904,741142,989988,419865,925218,345017,655071,297222,836528,400116,359086,623467,526917,702801,708825,134568,608421,126133,527472,1023693,375898,819744,13627,409827) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529597 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529597 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]