SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20883 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20883 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481321,399839,651410,510593,211182,204817,1004906,359870,916424,562729,540360,824427,679025,1018953,1020561,401171,375774,356244,314854,985372,578592,266068,579642,819817,434345,641254,333264,763647,835377,889179,378747,504376,118836,94004,895672,676890,5914,541381,300183,373886,443644,426527,517740,324910,464745,278540,796307,264341,638817,248537,1001360,985603,393066,178946,386056,749240,140425,287772,169355,215710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]