SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490133 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490133 [ RunTime:0.002277s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337414,119428,283160,456902,759175,108124,466879,701521,371163,906805,305760,148410,634003,65088,107602,127668,975700,677988,780248,299615,647134,336899,507017,379084,977564,465647,134656,529029,595054,646549,929645,834284,490786,626584,617479,809155,884266,384311,596207,74502,696166,605447,790455,29414,276862,616458,83572,111943,584005,201613,861379,421934,775884,213568,514110,162168,603811,950392,858658,379415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490133 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490133 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]