SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512063 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512063 [ RunTime:0.002538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307548,294618,849162,933808,449426,558171,991971,931542,246397,901247,75035,589151,885625,63354,1019891,7795,387835,1034486,904462,89630,39569,433134,375990,53820,971994,670417,444616,822315,674847,435854,778897,9941,562900,138107,882310,1035944,951572,168780,104204,448831,565254,368120,545115,727875,646184,308138,199005,608172,722772,523771,333069,998061,12791,1047459,586475,857920,838260,96628,909653,994331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003346s ]