SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499421 LIMIT 1 [ RunTime:0.000603s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499421 [ RunTime:0.004846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318178,762823,259619,574158,771484,925409,550110,218887,596813,1013716,43980,791237,341031,989954,274561,204727,284982,601520,814537,419439,143230,369090,228998,159913,122781,751696,602222,354973,1029703,1017297,3827,75621,602339,760323,917339,805618,1025552,459671,670109,913941,462002,239850,956627,365423,957566,896504,852786,491321,368828,970121,71769,471764,61107,515123,656891,414475,638399,1016030,465209,1040245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]