SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410921 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410921 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690622,760634,98263,563537,1027250,866189,282966,417461,354909,321092,706021,129343,58112,604207,182910,650376,543289,336808,643028,485552,38390,393775,174525,762937,714425,255210,844258,109084,302359,489833,274341,461227,106059,85423,882627,58226,867077,386572,616608,808580,1004357,508482,68188,850590,204694,959552,1005906,293220,405096,262585,173729,325540,395199,191903,457153,283244,306219,42197,732486,436301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410921 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410921 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001722s ]