SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111036 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111036 [ RunTime:0.002218s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (832650,978346,138240,949400,355380,615629,321313,12542,271127,360072,329991,402756,196594,377232,839711,707329,733946,833766,40853,154509,14964,320968,943618,810916,648930,902603,983448,365152,982864,708344,409197,601524,995896,486374,184195,12341,217165,761473,31992,918700,782659,520840,189263,917029,954890,746809,597216,885976,714520,993078,953218,707753,1027098,857577,352825,1003631,67934,178000,385168,456587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001258s ]