SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003208 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003208 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205852,540941,272180,325882,142815,1008511,329524,717697,255457,767542,285357,501850,747530,271016,820665,532053,452390,962334,532121,614863,589201,165842,858396,457097,624984,969222,336851,158351,645460,298343,817751,573513,453264,506801,170514,489417,23081,395347,987622,323104,813815,140037,446985,603548,738086,883419,200131,32782,232269,75660,836918,507003,203379,943732,877237,885163,88800,136221,82964,1018987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]