SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001711s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106324 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106324 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423798,120371,364575,141760,98539,174482,609439,898027,423088,266158,717253,251949,404260,26296,64912,97499,872830,952426,247072,593204,630402,446821,73204,930159,149054,749354,311546,265440,751840,446728,1016986,765576,196769,989485,1004828,789639,657947,200718,245259,482140,92252,518656,879568,416782,1009725,177808,953693,29870,1269,80113,746002,902341,737487,315380,828763,802467,917020,610786,805768,530256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106324 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106324 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]