SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341120 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341120 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308587,70855,933164,538843,89799,563156,350013,597387,270745,646180,251706,971418,308575,764947,447018,219089,368961,910168,306760,1042843,1040084,626341,479044,113459,429065,29439,273012,570481,444251,524943,701728,336784,200541,434217,300105,236142,120466,483551,430178,762100,792514,52616,572155,891168,963389,814483,353965,403116,415641,880642,17636,282409,513819,804570,134883,725574,1033898,961233,798863,406485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000827s ]