SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000883s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011312 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011312 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030204,594365,725527,654218,223370,276661,703879,749371,313371,784849,373806,424514,45669,628963,107810,302682,1005864,834368,79095,686775,345755,973398,911958,737509,939546,48563,88914,818945,897672,72542,1007766,848339,488072,671795,725897,727970,1027449,940926,624898,266853,615138,210352,782755,863503,554862,428192,322004,73630,328224,752645,794285,362533,176698,634098,1030666,542481,97320,262471,1006248,765791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001962s ]