SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 33798 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 33798 [ RunTime:0.002074s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598047,452274,24124,12312,498397,544475,271196,557552,537090,613851,236126,782722,954236,275862,254321,212016,601765,487729,306264,730364,540174,409673,771057,637356,590443,300687,472748,38518,779220,224437,719065,450675,464204,645581,591088,495965,822156,752168,805049,805186,536645,152173,12654,51646,348434,947324,677012,61928,438185,225830,617540,768517,688093,195259,846847,194959,6661,462702,148794,619005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 33798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 33798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]