SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566704 LIMIT 1 [ RunTime:0.000457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566704 [ RunTime:0.003114s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (786183,77421,512078,695643,721403,101226,95608,272203,200861,277266,58653,896100,193286,840039,636488,696939,1006717,307433,551096,975353,101203,583360,39101,868991,865807,658374,367221,694871,852709,365513,50641,769545,929997,481797,334929,625752,340769,789066,994262,90004,532249,734631,712800,215548,179930,632593,172718,568798,175371,898435,720746,117053,763833,938925,608725,456663,530519,375566,433304,460706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]