SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438726 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438726 [ RunTime:0.002129s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49928,4231,164781,629877,673003,848560,252939,616352,771546,379417,420385,257058,696488,836015,623547,152185,803732,1028763,706862,450002,300863,1001645,520251,659389,718842,188644,878650,954182,280871,808013,537069,1011587,741415,277831,131176,988444,405250,692769,863065,533998,140870,737210,84679,614668,598772,624350,801629,958027,593280,999993,85907,964819,883164,524176,479394,267802,426344,747406,902102,393426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438726 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438726 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]