SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 19353 LIMIT 1 [ RunTime:0.000555s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 19353 [ RunTime:0.003397s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52168,166167,415689,393799,191051,667329,191754,746074,312009,741728,139707,36336,86933,707460,351742,824904,902228,781781,787817,595194,591398,464201,913051,277046,819034,211247,473991,465827,922802,75180,1031738,230067,286384,217276,101796,106480,288150,1032922,529694,1031201,513631,344131,127377,358632,610025,30713,281137,461857,596352,592236,944285,551318,362680,838174,197576,327676,872461,847740,860100,153187) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 19353 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 19353 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003430s ]