SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 46762 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 46762 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214137,127548,1012666,439824,874101,1037098,270440,1013529,258687,636427,282787,480550,812308,494097,394528,320539,134562,997484,805126,634839,762483,595800,68626,13483,994385,858237,761250,442326,694927,89426,193444,3405,13360,822974,221557,447295,581484,115580,867693,554240,147253,751000,523469,692000,577572,619468,792479,1042913,400929,991832,31512,595470,870790,222139,283152,58459,335026,206453,262674,827223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 46762 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 46762 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]