SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016565 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016565 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (366047,914829,213444,842009,805581,339478,493106,39016,148163,488343,835685,940048,156204,662305,928841,241866,151003,118212,140602,648049,320407,372808,852599,514348,394848,818020,18823,449556,510739,353788,269152,217960,611930,168907,874093,9890,135746,977784,309182,71432,209078,794430,527939,247847,1002393,366137,358996,598873,236643,620019,696926,928689,442397,229937,693075,343179,495509,999706,20402,387062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005774s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016565 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016565 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]