SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002485s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425437 LIMIT 1 [ RunTime:0.001028s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425437 [ RunTime:0.005950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251798,816940,985869,238178,612625,410457,943908,21237,445741,164244,81807,480721,1047728,110834,623957,444410,286135,525620,984334,71797,1031145,239402,634372,160186,457736,701041,669917,172466,103546,82393,382239,571877,770476,850021,481771,408469,103035,1048022,714817,157486,1037126,347865,532311,1000156,68,355656,516231,980720,400271,450000,237491,340902,913614,50233,897700,230134,962181,108068,881705,986671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425437 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425437 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]