SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453230 LIMIT 1 [ RunTime:0.000989s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453230 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509356,198233,964614,990646,89995,670364,711422,213431,516520,514343,73867,888087,639308,948863,893908,79054,1005897,232269,449710,694906,557421,584149,59851,681973,12051,270482,1044556,785116,53565,114162,465922,144399,836521,153202,863920,1022343,53630,779994,858775,164063,286043,52328,870568,86660,74610,117122,1039279,724291,640317,379862,461369,782609,52842,51210,157032,140727,377093,849378,197395,357751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]