SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578912 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578912 [ RunTime:0.001736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (9634,696456,458215,420067,81689,785052,768669,637235,988341,495300,11528,804106,425470,1036246,773724,574730,238292,1033484,910591,306135,696640,817275,672174,359114,157516,542766,429885,627267,421951,455678,365938,815197,158785,523748,1042387,462629,504416,619357,661040,422373,486527,119804,617934,319854,153498,27871,163226,252521,541884,571542,691528,289005,799808,741340,914075,613678,32504,526077,48796,653004) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000390s ]