SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001511s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557411 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557411 [ RunTime:0.001896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (889490,97740,1035935,658764,575532,513897,542787,1024260,337350,480506,169524,767908,991085,849966,430126,270317,45071,922345,886587,78313,840889,52666,984961,206271,88313,316189,769095,940244,564066,1029956,282054,203263,563573,903116,963552,89803,213361,402020,467586,699473,931265,399738,79919,194610,980390,951228,329026,851088,504404,152785,536405,742388,923882,880309,1009853,253929,229397,597593,727107,956975) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]