SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291180 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291180 [ RunTime:0.001991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719711,935869,442220,1031914,88363,752196,763839,145137,1040865,677399,585335,676787,232426,612225,920411,636018,896927,761084,831217,501167,569826,940517,33729,264748,744562,250288,524483,830483,453437,626020,1039034,235208,923290,865828,942654,530788,488429,183464,679261,801852,753646,487595,895023,319051,336348,89551,974451,347989,561834,924149,296269,108551,219098,8359,585355,1019646,200666,833255,483095,555626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000783s ]