SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008414 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008414 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37373,538823,302330,349882,941902,650560,701026,418115,627582,419890,896657,70425,843677,671258,144657,42374,600453,357350,385804,144426,134476,881671,773526,220235,10190,334136,473809,152394,411129,491485,658789,607673,37488,535702,854881,469159,890222,544587,1028775,571120,774101,859925,456125,234953,622021,452833,761139,975744,508789,434388,468141,872665,569979,316427,1015541,933358,170897,958730,959741,765332) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]