SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579207 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579207 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (549240,62431,776411,545119,156020,25216,96715,653028,161090,527419,634081,168179,74958,726009,114437,994064,1039501,247246,708576,678927,561498,206939,843495,601991,901036,368343,659307,288364,480828,972084,375052,29686,31482,807930,511336,4446,1033416,967938,968693,330675,601049,469886,681609,764574,176500,825906,959548,456723,637614,276081,360287,906535,538360,987188,623993,140055,482228,206808,153806,653147) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]