SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29438 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29438 [ RunTime:0.003217s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702777,982605,789901,707898,606582,542051,180354,378714,781649,590229,418024,753900,629460,173538,371063,373062,278096,311264,876680,736948,902622,390052,840039,177158,231380,388623,869112,1037482,491843,657967,680967,208211,271668,1013356,947583,11834,153249,565999,849385,606395,801124,778560,984510,532591,958533,680399,627120,729554,810763,224680,862913,456715,846761,373140,429195,407227,96242,63360,243925,448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001748s ]