SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4672 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4672 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430500,628932,121459,1023936,129523,837743,481990,534324,190622,283645,185779,811407,281428,936183,444071,507996,182801,79650,92292,57027,40287,768725,616444,763188,760807,124609,922707,16848,366969,144872,749397,853810,112540,985283,1040393,571019,676459,601848,380908,844373,735826,936113,427069,962652,171623,311441,370244,791261,958675,898871,650613,609351,1032396,868793,107580,23675,931544,909787,863855,1004566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4672 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4672 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000711s ]