SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52480 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52480 [ RunTime:0.001974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719594,396317,616372,176100,426144,148447,612633,1033166,322515,109012,134099,555956,179755,106420,586697,17693,608293,387099,506540,617847,691804,199412,612727,343053,958677,439240,635445,32500,212118,277141,916799,598146,479544,1026788,174,325196,756471,82879,614973,556744,588945,546103,644828,1030940,1004782,486449,472186,973025,988562,935683,191895,619486,898198,243970,150413,761119,598010,124550,519795,822262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]