SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498529 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498529 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473132,835082,545798,263921,681172,198032,895630,803951,434751,505119,315494,282462,565643,996885,690363,1038055,354605,121272,281002,647773,598417,810540,625377,636993,565543,1033183,258442,723794,541944,662809,574332,110039,133931,144871,345429,611243,222066,1966,161491,566110,1026471,491158,408561,739055,935192,590905,611240,1016372,133789,849579,943250,45982,379457,806637,442524,243421,983547,247360,78829,558338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001097s ]