SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314117 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314117 [ RunTime:0.003104s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044312,511719,178084,472062,486238,640802,579048,872464,684671,375503,278542,591846,906379,640777,541237,238807,701327,1035187,210009,949833,495261,1044599,532537,524012,61066,762321,297510,877766,771208,469002,1022991,603029,133755,491431,916497,3838,903900,330489,952834,53350,577664,823467,701472,310508,984833,4963,206657,743806,764419,415968,116698,905512,208205,573132,161856,759849,282626,681449,540126,836990) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]