SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38308 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38308 [ RunTime:0.002010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28756,117727,238870,79350,427042,961221,1013640,877704,772140,754491,90224,574002,281134,1010412,1029246,76966,58773,770052,311483,1009960,724192,15042,226597,695224,370775,495267,522071,637480,256658,347886,408744,781435,741655,833298,162067,352998,7061,681181,653031,541070,214741,179390,599305,172099,127623,283709,283531,188016,185629,173856,615143,986339,762685,317,818378,69748,765808,384808,197699,18370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]