SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101226 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101226 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436343,629670,634179,978987,610262,247505,121371,628839,974603,765954,500211,151218,526285,17613,1048565,765692,599879,592969,30611,881230,984443,151646,238299,554146,645109,979442,279992,877945,751454,821159,44968,450407,855177,695679,248984,22182,217538,648358,882213,98848,664155,133094,476109,691090,238176,706064,883252,470377,540692,879647,143128,157321,385730,1021010,782964,1022172,322657,795281,281692,631943) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]