SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340683 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340683 [ RunTime:0.001508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (894805,915538,68831,140060,412761,381791,489850,595053,502775,877343,956911,440981,443531,249490,262849,54310,121184,949711,794655,406687,626380,252629,754166,441181,557376,369266,780443,884144,197745,735343,869496,359855,595469,120221,906737,771726,639617,565697,418276,276060,155643,600543,239371,293933,125073,464171,927331,139446,606045,669025,265129,502273,986514,543302,1031168,810292,348527,1029032,609578,261506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]